Problem Note 64614: Custom sorts that include values greater than 256 characters return errors in SAS® Visual Analytics
 |  |  |  |
Overview
If a data item with a custom sort includes a value that is greater than 256 characters, then you see errors when you try to use the data item, and when you open the Edit Custom Sort dialog box. The errors depend on your release of SAS Visual Analytics. There is no workaround that enables you to use a value that is greater than 256 characters in a custom sort.
Release 7.4
If you try to add the data item with the custom sort to an object, you see a red X in the lower right corner of the object and the tooltip contains this error:
If you try to edit the custom sort, the Edit Custom Sort dialog box contains an error that is similar to this:
Release 7.5
If you try to add the data item with the custom sort to an object, you see an error that is similar to this:
The same error appears if you try to edit the custom sort.
Release 8.2 and later
If you try to add the data item with the custom sort to an object, you see an error that is similar to this:
statements could not be parsed. (severity=2 reason=6 statusCode=2710055)
5 ERROR: The user-defined programming statements could not be parsed.
5 ERROR: Invalid character string constant.
5 ERROR: Failure opening table 'CUSTOMSORT'
5 ERROR: The action stopped due to errors.
debug=0x887ff837:TKCASTAB_PARSE_ERROR
The same error appears if you try to edit the custom sort.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Analytics | Linux for x64 | 7.4 | 7.51 | 9.4 TS1M4 | 9.4 TS1M7 |
| Microsoft® Windows® for x64 | 7.4 | 7.51 | 9.4 TS1M4 | 9.4 TS1M7 | ||
| SAS System | SAS Visual Analytics (on SAS Viya) | Linux for x64 | 8.2 | 2020.1 | Viya | Viya |